SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER  view v_tt_billvirtual_cmdraw
as
 select id as id,btype as btype,bkind as flowbkind ,
 bid as bid,bdate as flowbdate,bno as bno,
 productid as productid, quantity as quantity,price as price,
 amount as amount,eqty as eqty,eprice as eprice,eamt as eamt,
 state as state,vkind as vkind ,filid as flowfilid
 from tt_billvirtual
 where vkind =2


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

